Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_PUBLISHED_COLUMNS

`ALL_PUBLISHED_COLUMNS` describes the published source table columns accessible to the current user. This view is intended for use by Change Data Capture subscribers. This view does not display the `CHANGE_TABLE_SCHEMA` or `CHANGE_TABLE_NAME` columns.

Related Views

- `DBA_PUBLISHED_COLUMNS` describes all published source table columns in the database.

- `USER_PUBLISHED_COLUMNS` describes the published source table columns owned by the current user. This view does not display the `CHANGE_TABLE_SCHEMA` or `CHANGE_TABLE_NAME` columns.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`CHANGE_SET_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the change set
`CHANGE_TABLE_SCHEMA` | `VARCHAR2(30)` | `NOT NULL` | Associated change table owner
`CHANGE_TABLE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Associated change table name
`PUB_ID` | `NUMBER` | `NOT NULL` | Publication identifier
`SOURCE_SCHEMA_NAME` | `VARCHAR2(30)` | `NOT NULL` | Table owner in the source database
`SOURCE_TABLE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Table name in the source database
`COLUMN_NAME` | `VARCHAR2(30)` | `NOT NULL` | Column name
`DATA_TYPE` | `VARCHAR2(106)` |  | Column datatype
`DATA_LENGTH` | `NUMBER` | `NOT NULL` | Column length (in bytes)
`DATA_PRECISION` | `NUMBER` |  | Decimal precision for `NUMBER` datatype; binary precision for `FLOAT` datatype; `NULL` for all other datatypes
`DATA_SCALE` | `NUMBER` |  | Digits to the right of a decimal point in a number
`NULLABLE` | `VARCHAR2(1)` |  | Indicates whether nulls are allowed (`Y`) or not (`N`)

See Also: "DBA_PUBLISHED_COLUMNS" "USER_PUBLISHED_COLUMNS"